Hollie Green
Hollie Green
Reactions
-
Re: Check for Matching Values on Another Sheet
If you add an auto row or row number column that matches up to an auto row or row number column on your current sheet can probably get away with one formula. =IF(INDEX(COLLECT({Column 1 on reference …1 · -
Re: Team Schedule from a form submisson
This is how I have mine set up. It works really well although mine is time off rather than schedule but it would work for either. You will need to change the formulas on the calendar to include the t…1 · -
Re: Report Filter by date
I would recommend adding a past due column on the sheet you are referencing and use a formula to mark it as past due. Include that in your report and you can filter to Past due.1 · -
Re: Equivalent to Excel's =XLOOKUP?
Index/collect combination should work In Account Manager column on your reference sheet reference the account manager on your output sheet and the Catalog Number in each sheet. those in {} are on you…1 · -
Re: Activity Health
IF(NETWORKDAYS([Start Date]@row, TODAY()) / NETWORKDAYS([Start Date]@row, [End Date]@row < [% Complete]@row), "Green", "Yellow") this part of the formula is what is causing the…1 ·
